create table promos(
	id int not null identity primary key,
	dt smalldatetime not null default(getdate()),
	dt_beg smalldatetime not null,
	dt_end smalldatetime,
	title varchar(200) not null,
	info varchar(max)
);

create index ix_promos_beg on promos(dt_beg);
create index ix_promos_end on promos(dt_end);
go
